<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Shortcut-to-a-report qualification</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ol.whs2 { list-style:decimal; }
p.whs3 { font-size:9pt; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nRetrieving specific data from sources: Filters\nCreating a stand-alone filter\nShortcut-to-a-report qualification");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Shortcut-to-a-report qualification</h1>
<p>The results of an existing report can be used as a filter for another 
 report. You can use the first report itself as a filter inside a new report. 
 This type of filter is called a shortcut-to-a-report qualification.</p>
<p>For example, you have a Basic Revenue report. Without a filter, this 
 report shows all revenue for all regions and all products you carry. Next, 
 you use your Revenue By Brand report as a filter within the Basic Revenue 
 report. With its new filter, the Basic Revenue report now displays the 
 revenue generated only for those brands specified in the results of the 
 Revenue By Brand report.</p>
<p>You can also use a report as a filter and then add additional qualifications 
 to expand the overall filter definition. For example, you can take the 
 result set of one report showing all customers in the Southwest region, 
 place that result set as a filter into a new report, and add a new filter 
 qualification for active customers in the current year. The new report 
 displays all currently active customers in the Southwest region.</p>
<p>This approach shows you the value of creating some basic, relatively 
 simple reports in your project. Then you can make use of these basic reports 
 within shortcut-to-a-report filters to make the filter creation process 
 quicker.</p>
<p>To be used as a shortcut-to-a-report qualification, a report cannot 
 contain any of the following objects or be of any of the following report 
 types:</p>
<ul type="disc" class="whs1">
	
<li class=p><p>Consolidations</p></li>
	
<li class=p><p>Custom groups</p></li>
	
<li class=p><p>Data mart reports</p></li>
	
<li class=p><p>Freeform SQL reports: Reports created using MicroStrategy's 
 Freeform SQL functionality.</p></li>
	
<li class=p><p>OLAP cube reports: Reports that draw their data from 
 an OLAP cube source such as SAP Business Intelligence Warehouse (SAP-BI), 
 Microsoft Analysis Services (MSAS), or Hyperion Essbase (Essbase).</p></li>
</ul>
<h2>Shortcut-to-a-report qualifications and OLAP Services</h2>
<p>If you have MicroStrategy OLAP Services, be aware that a report's view 
 definition does not affect how the report is used in a shortcut-to-a-report 
 qualification. A report's data definition is the query that is sent to 
 your database to retrieve information for the report, whereas the report's 
 view definition determines how much of the retrieved information is displayed 
 in the report. When you use a report as a filter, the report's entire 
 data definition is considered; any view definitions do not influence the 
 filter conditions. For an introduction to the MicroStrategy OLAP Services 
 product, see the <span style="font-style: italic;"><I>MicroStrategy Basic 
 Reporting Guide</I></span>.</p>
<h2>To use a report as a filter in a shortcut-to-a-report qualification</h2>
<ol type="1" class="whs2">
	
<li class=p><p>On the project's main page, click <span style="font-weight: bold;"><B>Create 
 Filter</B></span>. The New Filter page opens.</p></li>
	
<li class=p><p>In the pane on the left, navigate to the report you 
 want to use as a filter.</p></li>
	
<li class=p><p>Right-click the report and select <span style="font-weight: bold;"><B>Add 
 to Filter</B></span>.</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>If DHTML is 
 disabled, select the report and click <span style="font-weight: bold;"><B>Add 
 &gt;</B></span> to add the report to the Filter panel.</p></li>
	</ul>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>File</B></span> 
 menu, select <span style="font-weight: bold;"><B>Save As</B></span>. The Save 
 As dialog box opens.</p></li>
	
<li style=" font-size: 9pt; " class=p><p><span style="font-size: 9pt;"><font size=1 style="font-size:9pt;">Navigate 
 to the folder where you want to save the filter. Enter a </font></span><span 
 style="font-size: 9pt; font-weight: bold;"><font size=1 style="font-size:9pt;"><B>Name</B></font></span><span style="font-size: 9pt;"><font size=1 style="font-size:9pt;"> 
 and </font></span><span style="font-size: 9pt; font-weight: bold;"><font size=1 style="font-size:9pt;"><B>Description</B></font></span><span 
 style="font-size: 9pt;"><font size=1 style="font-size:9pt;"> for the filter, and click </font></span><span style="font-size: 9pt; font-weight: bold;"><font size=1 style="font-size:9pt;"><B>OK</B></font></span><span 
 style="font-size: 9pt;"><font size=1 style="font-size:9pt;">. Your new filter is saved.</font></span></p></li>
</ol>
<p class="whs3">The filter you created can now be added to a 
 report. For steps, see 
<a href="Creating_a_filter.htm" style="font-size: 9pt;">Adding 
 a stand-alone filter to a report</a>.</p>
<p>&nbsp;</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
